SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '207d0e532ff8d71f6e4296765acdf7bf74fca992ad385a5157d407a74fca8397' 
  AND token = 'KT01vNiH1C9pqo6taOW0IL52IcBuX1JFgXJThrnDfNw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}