UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N7KZ0PfHU2sXlYIkhkFksDC2zqp9amNJ4xoi869D+yE='
WHERE
key_id = '079372d7021bd1e728fb23eb8f4d2b3fd056d4750ca21aeaf1006ecc157a00e3'
AND (
token = 'N7KZ0PfHU2sXlYIkhkFksDC2zqp9amNJ4xoi869D+yE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)