SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'ebf347f9102dcf8e7984b3c1b51f2ce1bad9201fd6c78dc66c97ad9f4d3754ea' 
  AND token = 'Rn0GjcX4ZPpMN711Dj4lO4wuxLkg70o+vv2E4O4iFtg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}