UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VizpDSU3zzM3n+ZB5yq/TFkLXW8IXukYBmL8xot+0wk='
WHERE
key_id = 'c710c8827768010c7bc5cce2f51c8d89783fcd1992ffb0461217c5ae03d3ef76'
AND (
token = 'VizpDSU3zzM3n+ZB5yq/TFkLXW8IXukYBmL8xot+0wk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)