UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bzfgGdtXzJwPi+ShVnj0RfAOr6s3Dk6dEM3pmxUMXhY='
WHERE
key_id = 'b580eaf2153daa3caaa851f8e6f3d8e11d0bb6ef18e2cdf590dd49639a4ff0a6'
AND (
token = 'bzfgGdtXzJwPi+ShVnj0RfAOr6s3Dk6dEM3pmxUMXhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)