UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mXcmJMaocLFPzYlWn+MGoHUjvDntXLEpiav64Os3Ku4='
WHERE
key_id = 'f2624c3ca438feae62a3d213e3eaf1e686e9c1f2cc899109561258c5e718dab0'
AND (
token = 'mXcmJMaocLFPzYlWn+MGoHUjvDntXLEpiav64Os3Ku4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)