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