UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fyMQ+msF7rc/ra+4KjQuJMqYl6zjDPME+lTpx6PMlcM=' 
WHERE 
  key_id = 'a69ae0025b3411e6f65c30b0c0574e046bf5b9de76dc48e401ad1af9dd3fe097' 
  AND (
    token = 'fyMQ+msF7rc/ra+4KjQuJMqYl6zjDPME+lTpx6PMlcM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047