UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qvPgpywA9bbHSAv9f6BGU5yYGGUKJUyWCgC4YVX+Fv8='
WHERE
key_id = '46cfa85e37f2bf9136779320ec6caf9d4a623750f29de1e1f3aee2068ee15e3d'
AND (
token = 'qvPgpywA9bbHSAv9f6BGU5yYGGUKJUyWCgC4YVX+Fv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)