UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WfMHU7pwHQXGl6cE38a2G0xyuPIyh+3BzOxwDINwZWw='
WHERE
key_id = 'bc2a3dc8a1c681acf59ce78ff88798ef29166dfb7d18f55f56c9bdd0ca8ce4a7'
AND (
token = 'WfMHU7pwHQXGl6cE38a2G0xyuPIyh+3BzOxwDINwZWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)