UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v8A4YRnqLPHiwV/C0o89UibQy/sU0y1yL90OjVPNSEw='
WHERE
key_id = 'cf4af9c0914963cd45c998c6445468aca80cceb15e2d103072f680c544f1076e'
AND (
token = 'v8A4YRnqLPHiwV/C0o89UibQy/sU0y1yL90OjVPNSEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)