UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'poiuXbYaYYaRusH71WCXmubAL6Mqig3LPHcOoQgRyxs='
WHERE
key_id = '7dfa9a36533f4428cd158a9959c8506bf5e5ec5bd3a645fcd349737f4a5afa5d'
AND (
token = 'poiuXbYaYYaRusH71WCXmubAL6Mqig3LPHcOoQgRyxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)