UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nobHZM89t/lGNnx7tXm6+lnJms3VM3M19dh3BVoKd8c='
WHERE
key_id = 'aeac7d09287fa0b3b09aa5a7493c7750d5bb6e76db3d56f06552ec077c7b5ce3'
AND (
token = 'nobHZM89t/lGNnx7tXm6+lnJms3VM3M19dh3BVoKd8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)