UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jbqCbt9xLOSHF6xnGVwcM1Dv8z69NEjud1ZFOiL7YKk='
WHERE
key_id = '77e1b7ebf65139e2ff542832ebd02f1a6c5a83a3287338d0139c0b1b7195f12a'
AND (
token = 'jbqCbt9xLOSHF6xnGVwcM1Dv8z69NEjud1ZFOiL7YKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)