SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'caffc4c1ea7f3aabe2101c50d061f16f73bc5e1eda9d2bb8f4c575ccc46f9c41' 
  AND token = '05QTrruhncmZjqNxD6LeUW/PxQyDEIu4dXSomLBq5HI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00044

JSON explain

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