UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vQkFrQFBkA1XiPVyrBBcvf7HQN3k11+kSi7w9YCbRA='
WHERE
key_id = 'e294c0c90e2e2ec711d3a5bbf117bdcf88a9475636616d47b776e1a06fc8ede6'
AND (
token = '6vQkFrQFBkA1XiPVyrBBcvf7HQN3k11+kSi7w9YCbRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)