UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G4sSycPFmrP9H3iTPGM3vunrAhIcWC91xZcB7jyiois='
WHERE
key_id = 'dbad475d7bdb3d2ceaf6ff5b6af34b09a3b65059e4dadf9c123a0696936f2c7e'
AND (
token = 'G4sSycPFmrP9H3iTPGM3vunrAhIcWC91xZcB7jyiois='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)