UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xNuWI0rSPr2PHg54XKMZwmbMCsh0OWAhW5n2ButS5g8='
WHERE
key_id = '97e7449bc195ddcf8df94d96200cfc757003c635185f448f8d728a0ff8092425'
AND (
token = 'xNuWI0rSPr2PHg54XKMZwmbMCsh0OWAhW5n2ButS5g8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)