UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6PiYMcC4xq9pggrQJVoD6P60dnBI1dR6kJEvV9xMJ3k='
WHERE
key_id = '50c3531befc56eaa5bdd5e2a3cc88d89fd5d54c5ff227d1d5b6c06e69713d7db'
AND (
token = '6PiYMcC4xq9pggrQJVoD6P60dnBI1dR6kJEvV9xMJ3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)