UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FrlFZrQbs8eKiQhC9prue6Uhb5rbApyeEfqf9izVdqE='
WHERE
key_id = 'b94532acf97653d2a5aa3e5b308c34c76fe734356e66f7ea9fd3387b2a118401'
AND (
token = 'FrlFZrQbs8eKiQhC9prue6Uhb5rbApyeEfqf9izVdqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)