UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b1QeGFhA/j+ciyy49/nfk6mdyX7jvA5fphcwW22q7AY='
WHERE
key_id = 'd94b6f713c580fb02e1c1e3f0917449a88e4a035e04bb2c8ed6e41314de09c76'
AND (
token = 'b1QeGFhA/j+ciyy49/nfk6mdyX7jvA5fphcwW22q7AY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)