UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'blGFnnay9EoFVz/Ox5PW2vXWvbdxAJE5WIS97Wi46YQ='
WHERE
key_id = '47aeb2ed9be914fef6f3da0f562bf37ce2ff952a4aa40b9da91471b5d8955290'
AND (
token = 'blGFnnay9EoFVz/Ox5PW2vXWvbdxAJE5WIS97Wi46YQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)