UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qbf9a8zWoYHiN4XxKizSDXrGXTN685jbPI7O9CPW04E='
WHERE
key_id = '2cb46c77eb4eafcf83003275ae1ffe848d4c1ba6760fc045d5b6a9369bc2c19b'
AND (
token = 'qbf9a8zWoYHiN4XxKizSDXrGXTN685jbPI7O9CPW04E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)