UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KoTyO29+HUxOjSMtn406eERpGS66QCI+xfhXNKe9l4g='
WHERE
key_id = '1c96247cbc38e2aa8c99fa00b33d2ecc297c031b58ca1f2a3ea8947271bfeb33'
AND (
token = 'KoTyO29+HUxOjSMtn406eERpGS66QCI+xfhXNKe9l4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)