UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/gnsBbIEhj8g3bHv19KlIM4sCv4eG4J0QbBNe12UisE=' 
WHERE 
  key_id = '79a886418e67d617f8fa30b2b9793ee2c25ee1c9fae0103fa7ca844ec88d309c' 
  AND (
    token = '/gnsBbIEhj8g3bHv19KlIM4sCv4eG4J0QbBNe12UisE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033