UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xTf7bZP3CZUK495HcRI0HtUtt7s9C630dgwHWGSQ9b4='
WHERE
key_id = '5f7b776d905fd5df0c4ea36a9e5f41b57cd21578ac18e13ec7acd38b2585ae1a'
AND (
token = 'xTf7bZP3CZUK495HcRI0HtUtt7s9C630dgwHWGSQ9b4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)