UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SmiqxXNEKOiYf/uKeMPKgaBraHbA1P2yH0zau7GrHSs='
WHERE
key_id = 'c9d99b36b7198b92bfa0a6848689acb7c3348acaddcd890bf7786db88d5abffe'
AND (
token = 'SmiqxXNEKOiYf/uKeMPKgaBraHbA1P2yH0zau7GrHSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)