SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '4c91fd5a6099166741e97d64c0a7e55714802e39d597088e2c587553dd11b892' 
  AND token = 'ZgpvNWZcNzvn4mLonP0pk6i6HtyXXF9KOiCfyJJHmMw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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