UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnZmabicBa9MpvmoEJaFEQc+18To+HIyK0U/LkY8SSo='
WHERE
key_id = '9986e2a432d0a11ead0ce0fc90707f26d122b2bc155d9c52620a21ee346683be'
AND (
token = 'ZnZmabicBa9MpvmoEJaFEQc+18To+HIyK0U/LkY8SSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)