UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r2R9q460PERrARoW6+SYdJ7Q6qelkFRvpGU40bFrIwg='
WHERE
key_id = '62797e3f571bce5e96231f199b44e8b8cfe54fffae77975c142e5f545eed7a36'
AND (
token = 'r2R9q460PERrARoW6+SYdJ7Q6qelkFRvpGU40bFrIwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)