UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yUr8Q1rNaLuYZxVkuRuVBYplohIPCylxIOAx8dcyTEk='
WHERE
key_id = '24195f709f5172da280c58a73e6d93078065577a32e8f58bfa084ba2220b2d20'
AND (
token = 'yUr8Q1rNaLuYZxVkuRuVBYplohIPCylxIOAx8dcyTEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)