UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VFcjpnIzzM6IgTUimmWsXUXS+c2yUCw58p+efYv+BpU='
WHERE
key_id = 'a29f18c5b84d3e3a293b8c25b99426caa440258600ecaf43f4074756a00afa91'
AND (
token = 'VFcjpnIzzM6IgTUimmWsXUXS+c2yUCw58p+efYv+BpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)