UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HuSfAlXNKA2x41JZX+27dhS6xZSf6mZovzEDa7AEW/g='
WHERE
key_id = 'f0f4ab0a5284936e2ed65764def7e216c9d778cde6a3ad4462f12c0a6ab1190a'
AND (
token = 'HuSfAlXNKA2x41JZX+27dhS6xZSf6mZovzEDa7AEW/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)