SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '162467271e0acfc8f894fe0b9488dec5455dfbc63b563db81a7594b188762ef2' 
  AND token = 'CXyzDDbbL4ZT2xXuIiO9PzE+bgrEzzXW8mtRZR6/pXA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

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