UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qvrmvzsFpiCMl9If2TcM2n7rLmEV2eeFTeaN2NVIqEM='
WHERE
key_id = 'c919a7e4101f06420d236d0271208a0a3075c5b726639009ea9b8fcef4e50770'
AND (
token = 'qvrmvzsFpiCMl9If2TcM2n7rLmEV2eeFTeaN2NVIqEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)