UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXd0kxlqyk9JV3maHjE3uk4/WBC/KJFdFo1mpSRctVA='
WHERE
key_id = '577c7006d0ceaf01825b4ef4272306ce6ff02294d6181fe12cd3ad976ff1508a'
AND (
token = 'BXd0kxlqyk9JV3maHjE3uk4/WBC/KJFdFo1mpSRctVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)