SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1175d4d30494ad1652fdd7153183f71dd4a25d403121962b8bcf38ecb93fdf80' 
  AND token = 'Fbl0lbK7Z7scWU1yp6+xAli0tJAv+7Y8S958j8xTLrg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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