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